-- @author lixiyong01
-- @date 2023.11.14
-- 健康分报警工单

CREATE TABLE `hdp_lbg_supin_zplisting.app_zp_rock_health_score_ticket`(
    `event_id` string COMMENT '工单id，动态生成唯一值：时间14+随机数8',
    `category` string COMMENT '问题类型，[project team owner_id,team]',
    `responser` string COMMENT '工单处理人',
    `subject` string COMMENT '工单主题，显示标题',
    `description` string COMMENT '工单内容'
) COMMENT '治理项-健康分工单'
PARTITIONED BY (`dt` string)

-- 22位
select concat(from_unixtime(unix_timestamp(),'yyyyMMddHHmmss'),cast(rand() * 100000000 as int))